Entity-Generating Schema Transformations for Entity-Relationship Models
نویسنده
چکیده
The paper is a contribution to the problem of semantics-preserving schema restructuring. First, the notion of schema transformation is precisely analysed, its properties of reversibility are stated and an adequate notation is proposed. Then, the paper develops a general family of entity-generating transformations, i.e. operations that add/remove entity types in a schema. This generic transformation is proved to be able to generate not only a large number of popular E-R schema transformations, but also some powerful new ones.
منابع مشابه
Automatic Migration and Wrapping of Database Applications - A Schema Transformation Approach
Both the federated approach and the mediator approach to database integration require that semantic diierences between schemas be resolved by a process of schema transformation. Data, queries and updates subsequently passed between schemas need to be transformed accordingly. We have developed a general framework to support the schema transformation process. This framework consists of a graph-ba...
متن کاملA Formalisation of Semantic Schema
| Several methodologies for the semantic integration of databases have been proposed in the literature. These often use a variant of the Entity-Relationship (ER) model as the common data model. To aid the schema conforming, merging and restructuring phases of the semantic integration process, various transformations have been deened that map between ER representations which are in some sense eq...
متن کاملRestructuring of Relational Schemas
Schema restructuring is part of both database design and database reorganization, which are expressions of the specification and evolution of an information system. Entity-Relationship(ER) consistency expresses the capability of relational databases to model information oriented systems. A relational schema consistmg of relation schemes, together with key and inclusion dependencies, is said to ...
متن کاملSAMSTARplus: An Automatic Tool for Generating Multi- Dimensional Schemas from an Entity-Relationship Diagram
This paper presents a tool that automatically generates multidimensional schemas for data warehouses from OLTP entity-relationship diagrams (ERDs). Based on user’s input parameters, it generates star schemas, snowflake schemas, or a fact constellation schema by taking advantage of only structural information of input ERDs. Hence, SAMSTARplus can help users reduce efforts for designing data ware...
متن کاملA Formalisation of Semantic Schema Integration
Several methodologies for the semantic integration of databases have been proposed in the literature. These often use a variant of the Entity-Relationship (ER) model as the common data model. To aid the schema conforming, merging and restructuring phases of the semantic integration process, various transformations have been deened that map between ER representations which are in some sense equi...
متن کامل